Pandas Profiling Report

Dataset statistics

Number of variables	20
Number of observations	42307
Missing cells	1771
Missing cells (%)	0.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	6.8 MiB
Average record size in memory	168.0 B

Variable types

Numeric	10
Categorical	5
DateTime	2
Text	3

Alerts

`LowDoc` is highly imbalanced (63.8%)	Imbalance
`MIS_Status` is highly imbalanced (50.8%)	Imbalance
`RevLineCr` has 1079 (2.6%) missing values	Missing
`LowDoc` has 531 (1.3%) missing values	Missing
`NoEmp` has 2994 (7.1%) zeros	Zeros
`CreateJob` has 28889 (68.3%) zeros	Zeros
`RetainedJob` has 26056 (61.6%) zeros	Zeros
`FranchiseCode` has 26392 (62.4%) zeros	Zeros
`Sector` has 9798 (23.2%) zeros	Zeros

Reproduction

Analysis started	2024-02-06 11:48:25.041720
Analysis finished	2024-02-06 11:48:50.408340
Duration	25.37 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

Term
Real number (ℝ)

Distinct	228
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	108.60167

Minimum	0
Maximum	360
Zeros	94
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	661.0 KiB

Quantile statistics

Minimum	0
5-th percentile	13
Q1	56
median	82
Q3	168
95-th percentile	293
Maximum	360
Range	360
Interquartile range (IQR)	112

Descriptive statistics

Standard deviation	84.569847
Coefficient of variation (CV)	0.77871587
Kurtosis	-0.28186028
Mean	108.60167
Median Absolute Deviation (MAD)	30
Skewness	1.0246757
Sum	4594611
Variance	7152.0589
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
82	3649	8.6%
83	2863	6.8%
84	1546	3.7%
57	1325	3.1%
81	1300	3.1%
58	1295	3.1%
59	1161	2.7%
56	1046	2.5%
240	892	2.1%
241	875	2.1%
Other values (218)	26355	62.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	94	0.2%
1	54	0.1%
2	75	0.2%
3	62	0.1%
4	91	0.2%
5	140	0.3%
6	145	0.3%
7	158	0.4%
8	188	0.4%
9	232	0.5%

Value	Count	Frequency (%)
360	1	< 0.1%
325	7	< 0.1%
312	11	< 0.1%
311	22	0.1%
310	19	< 0.1%
309	45	0.1%
308	69	0.2%
306	72	0.2%
303	122	0.3%
302	130	0.3%

NoEmp
Real number (ℝ)

ZEROS

Distinct	196
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.7043043

Minimum	0
Maximum	202
Zeros	2994
Zeros (%)	7.1%
Negative	0
Negative (%)	0.0%
Memory size	661.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	4
Q3	12
95-th percentile	40
Maximum	202
Range	202
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	17.488022
Coefficient of variation (CV)	1.8020892
Kurtosis	40.742751
Mean	9.7043043
Median Absolute Deviation (MAD)	3
Skewness	5.4942159
Sum	410560
Variance	305.83092
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	5563	13.1%
2	5518	13.0%
4	4902	11.6%
1	4433	10.5%
5	3146	7.4%
0	2994	7.1%
6	1691	4.0%
15	975	2.3%
16	914	2.2%
7	901	2.1%
Other values (186)	11270	26.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2994	7.1%
1	4433	10.5%
2	5518	13.0%
3	5563	13.1%
4	4902	11.6%
5	3146	7.4%
6	1691	4.0%
7	901	2.1%
8	602	1.4%
9	544	1.3%

Value	Count	Frequency (%)
202	1	< 0.1%
198	1	< 0.1%
197	2	< 0.1%
195	1	< 0.1%
194	2	< 0.1%
193	2	< 0.1%
192	2	< 0.1%
191	3	< 0.1%
189	3	< 0.1%
188	2	< 0.1%

NewExist
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	661.0 KiB

1.0	33405
2.0	8902

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	126921
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	1.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	33405	79.0%
2.0	8902	21.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	33405	79.0%
2.0	8902	21.0%

Most occurring characters

Value	Count	Frequency (%)
.	42307	33.3%
0	42307	33.3%
1	33405	26.3%
2	8902	7.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	84614	66.7%
Other Punctuation	42307	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	42307	50.0%
1	33405	39.5%
2	8902	10.5%

Other Punctuation

Value	Count	Frequency (%)
.	42307	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	126921	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	42307	33.3%
0	42307	33.3%
1	33405	26.3%
2	8902	7.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	126921	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	42307	33.3%
0	42307	33.3%
1	33405	26.3%
2	8902	7.0%

CreateJob
Real number (ℝ)

ZEROS

Distinct	49
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.1837285

Minimum	0
Maximum	70
Zeros	28889
Zeros (%)	68.3%
Negative	0
Negative (%)	0.0%
Memory size	661.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	2
95-th percentile	13
Maximum	70
Range	70
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	5.0939801
Coefficient of variation (CV)	2.3326985
Kurtosis	23.628207
Mean	2.1837285
Median Absolute Deviation (MAD)	0
Skewness	4.0134768
Sum	92387
Variance	25.948633
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
0	28889	68.3%
3	3293	7.8%
1	2519	6.0%
4	1334	3.2%
8	665	1.6%
9	579	1.4%
2	548	1.3%
10	511	1.2%
7	484	1.1%
11	448	1.1%
Other values (39)	3037	7.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	28889	68.3%
1	2519	6.0%
2	548	1.3%
3	3293	7.8%
4	1334	3.2%
5	73	0.2%
6	250	0.6%
7	484	1.1%
8	665	1.6%
9	579	1.4%

Value	Count	Frequency (%)
70	1	< 0.1%
60	3	< 0.1%
57	5	< 0.1%
56	5	< 0.1%
50	6	< 0.1%
48	12	< 0.1%
47	15	< 0.1%
46	19	< 0.1%
45	16	< 0.1%
40	17	< 0.1%

RetainedJob
Real number (ℝ)

ZEROS

Distinct	83
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.4781478

Minimum	0
Maximum	140
Zeros	26056
Zeros (%)	61.6%
Negative	0
Negative (%)	0.0%
Memory size	661.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	3
95-th percentile	15
Maximum	140
Range	140
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	8.1136484
Coefficient of variation (CV)	2.3327497
Kurtosis	40.299963
Mean	3.4781478
Median Absolute Deviation (MAD)	0
Skewness	5.1823038
Sum	147150
Variance	65.83129
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	26056	61.6%
1	3846	9.1%
8	1227	2.9%
9	1060	2.5%
3	1057	2.5%
7	986	2.3%
10	837	2.0%
2	803	1.9%
11	795	1.9%
12	769	1.8%
Other values (73)	4871	11.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	26056	61.6%
1	3846	9.1%
2	803	1.9%
3	1057	2.5%
4	687	1.6%
5	329	0.8%
6	575	1.4%
7	986	2.3%
8	1227	2.9%
9	1060	2.5%

Value	Count	Frequency (%)
140	1	< 0.1%
136	1	< 0.1%
130	1	< 0.1%
118	1	< 0.1%
102	2	< 0.1%
100	4	< 0.1%
95	4	< 0.1%
91	7	< 0.1%
90	6	< 0.1%
87	7	< 0.1%

FranchiseCode
Real number (ℝ)

ZEROS

Distinct	271
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1955.056

Minimum	0
Maximum	90709
Zeros	26392
Zeros (%)	62.4%
Negative	0
Negative (%)	0.0%
Memory size	661.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	1
Maximum	90709
Range	90709
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	10541.389
Coefficient of variation (CV)	5.3918602
Kurtosis	35.690306
Mean	1955.056
Median Absolute Deviation (MAD)	0
Skewness	5.919311
Sum	82712555
Variance	1.1112088 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	26392	62.4%
1	14033	33.2%
960	182	0.4%
27760	21	< 0.1%
74750	20	< 0.1%
72590	18	< 0.1%
73000	18	< 0.1%
73675	15	< 0.1%
34850	15	< 0.1%
36680	14	< 0.1%
Other values (261)	1579	3.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	26392	62.4%
1	14033	33.2%
960	182	0.4%
5725	1	< 0.1%
6410	1	< 0.1%
9120	1	< 0.1%
9450	1	< 0.1%
10482	1	< 0.1%
10494	1	< 0.1%
10528	3	< 0.1%

Value	Count	Frequency (%)
90709	1	< 0.1%
89769	2	< 0.1%
89655	1	< 0.1%
89640	2	< 0.1%
89352	1	< 0.1%
89350	1	< 0.1%
88875	2	< 0.1%
88355	1	< 0.1%
87350	3	< 0.1%
86720	3	< 0.1%

RevLineCr
Categorical

MISSING

Distinct	4
Distinct (%)	< 0.1%
Missing	1079
Missing (%)	2.6%
Memory size	661.0 KiB

N	27618
Y	7353
0	5561
T	696

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	41228
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	N
2nd row	0
3rd row	N
4th row	N
5th row	N

Common Values

Value	Count	Frequency (%)
N	27618	65.3%
Y	7353	17.4%
0	5561	13.1%
T	696	1.6%
(Missing)	1079	2.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
n	27618	67.0%
y	7353	17.8%
0	5561	13.5%
t	696	1.7%

Most occurring characters

Value	Count	Frequency (%)
N	27618	67.0%
Y	7353	17.8%
0	5561	13.5%
T	696	1.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	35667	86.5%
Decimal Number	5561	13.5%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	27618	77.4%
Y	7353	20.6%
T	696	2.0%

Decimal Number

Value	Count	Frequency (%)
0	5561	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	35667	86.5%
Common	5561	13.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	27618	77.4%
Y	7353	20.6%
T	696	2.0%

Common

Value	Count	Frequency (%)
0	5561	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	41228	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	27618	67.0%
Y	7353	17.8%
0	5561	13.5%
T	696	1.7%

LowDoc
Categorical

IMBALANCE MISSING

Distinct	6
Distinct (%)	< 0.1%
Missing	531
Missing (%)	1.3%
Memory size	661.0 KiB

N	34313
Y	5277
0	684
A	570
S	540

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	41776
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	N
2nd row	N
3rd row	N
4th row	N
5th row	N

Common Values

Value	Count	Frequency (%)
N	34313	81.1%
Y	5277	12.5%
0	684	1.6%
A	570	1.3%
S	540	1.3%
C	392	0.9%
(Missing)	531	1.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
n	34313	82.1%
y	5277	12.6%
0	684	1.6%
a	570	1.4%
s	540	1.3%
c	392	0.9%

Most occurring characters

Value	Count	Frequency (%)
N	34313	82.1%
Y	5277	12.6%
0	684	1.6%
A	570	1.4%
S	540	1.3%
C	392	0.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	41092	98.4%
Decimal Number	684	1.6%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	34313	83.5%
Y	5277	12.8%
A	570	1.4%
S	540	1.3%
C	392	1.0%

Decimal Number

Value	Count	Frequency (%)
0	684	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	41092	98.4%
Common	684	1.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	34313	83.5%
Y	5277	12.8%
A	570	1.4%
S	540	1.3%
C	392	1.0%

Common

Value	Count	Frequency (%)
0	684	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	41776	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	34313	82.1%
Y	5277	12.6%
0	684	1.6%
A	570	1.4%
S	540	1.3%
C	392	0.9%

DisbursementDate
Date

Distinct	916
Distinct (%)	2.2%
Missing	150
Missing (%)	0.4%
Memory size	661.0 KiB

Minimum	1977-06-14 00:00:00
Maximum	2073-12-06 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

MIS_Status
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	661.0 KiB

1	37767
0	4540

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	42307
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	37767	89.3%
0	4540	10.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	37767	89.3%
0	4540	10.7%

Most occurring characters

Value	Count	Frequency (%)
1	37767	89.3%
0	4540	10.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	42307	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	37767	89.3%
0	4540	10.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	42307	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	37767	89.3%
0	4540	10.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	42307	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	37767	89.3%
0	4540	10.7%

Sector
Real number (ℝ)

ZEROS

Distinct	24
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32.933439

Minimum	0
Maximum	81
Zeros	9798
Zeros (%)	23.2%
Negative	0
Negative (%)	0.0%
Memory size	661.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	22
median	33
Q3	44
95-th percentile	72
Maximum	81
Range	81
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	22.291386
Coefficient of variation (CV)	0.67686178
Kurtosis	-0.89972227
Mean	32.933439
Median Absolute Deviation (MAD)	11
Skewness	-0.11631806
Sum	1393315
Variance	496.90589
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
0	9798	23.2%
42	7337	17.3%
33	5050	11.9%
44	3868	9.1%
23	3867	9.1%
61	2505	5.9%
72	2478	5.9%
22	1998	4.7%
62	1191	2.8%
53	896	2.1%
Other values (14)	3319	7.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	9798	23.2%
11	7	< 0.1%
21	28	0.1%
22	1998	4.7%
23	3867	9.1%
31	138	0.3%
32	865	2.0%
33	5050	11.9%
42	7337	17.3%
44	3868	9.1%

Value	Count	Frequency (%)
81	169	0.4%
72	2478	5.9%
71	337	0.8%
62	1191	2.8%
61	2505	5.9%
56	672	1.6%
55	29	0.1%
54	267	0.6%
53	896	2.1%
52	84	0.2%

ApprovalDate
Date

Distinct	3868
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Memory size	661.0 KiB

Minimum	1977-03-11 00:00:00
Maximum	2073-10-17 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

ApprovalFY
Real number (ℝ)

Distinct	38
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2001.5378

Minimum	1974
Maximum	2014
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	661.0 KiB

Quantile statistics

Minimum	1974
5-th percentile	1991
Q1	1997
median	2003
Q3	2006
95-th percentile	2010
Maximum	2014
Range	40
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	5.8605268
Coefficient of variation (CV)	0.0029280121
Kurtosis	0.16185187
Mean	2001.5378
Median Absolute Deviation (MAD)	4
Skewness	-0.69419236
Sum	84679059
Variance	34.345775
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
2004	4708	11.1%
2007	3777	8.9%
2006	3314	7.8%
2003	3293	7.8%
2005	2712	6.4%
1995	2552	6.0%
2000	2295	5.4%
1996	1739	4.1%
2002	1726	4.1%
2008	1723	4.1%
Other values (28)	14468	34.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1974	4	< 0.1%
1977	5	< 0.1%
1979	21	< 0.1%
1980	56	0.1%
1981	13	< 0.1%
1982	78	0.2%
1983	80	0.2%
1984	79	0.2%
1985	134	0.3%
1986	77	0.2%

Value	Count	Frequency (%)
2014	9	< 0.1%
2013	105	0.2%
2012	318	0.8%
2011	781	1.8%
2010	948	2.2%
2009	1158	2.7%
2008	1723	4.1%
2007	3777	8.9%
2006	3314	7.8%
2005	2712	6.4%

City
Text

Distinct	2703
Distinct (%)	6.4%
Missing	0
Missing (%)	0.0%
Memory size	661.0 KiB

Length

Max length	30
Median length	27
Mean length	8.8926892
Min length	3

Characters and Unicode

Total characters	376223
Distinct characters	65
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	827 ?
Unique (%)	2.0%

Sample

1st row	PHOENIX
2nd row	MCALESTER
3rd row	HAWTHORNE
4th row	NASHVILLE
5th row	POMONA

Value	Count	Frequency (%)
city	1492	2.7%
san	1325	2.4%
houston	1224	2.3%
pittsburgh	958	1.8%
lake	812	1.5%
salt	716	1.3%
new	616	1.1%
philadelphia	614	1.1%
nashville	600	1.1%
pomona	584	1.1%
Other values (2347)	45399	83.5%

Most occurring characters

Value	Count	Frequency (%)
A	36799	9.8%
E	32773	8.7%
O	29514	7.8%
L	29423	7.8%
N	28734	7.6%
I	24008	6.4%
S	23939	6.4%
R	22162	5.9%
T	20421	5.4%
C	13141	3.5%
Other values (55)	115309	30.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	353936	94.1%
Space Separator	12034	3.2%
Lowercase Letter	9453	2.5%
Other Punctuation	370	0.1%
Open Punctuation	262	0.1%
Close Punctuation	151	< 0.1%
Decimal Number	10	< 0.1%
Dash Punctuation	6	< 0.1%
Modifier Symbol	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	36799	10.4%
E	32773	9.3%
O	29514	8.3%
L	29423	8.3%
N	28734	8.1%
I	24008	6.8%
S	23939	6.8%
R	22162	6.3%
T	20421	5.8%
C	13141	3.7%
Other values (16)	93022	26.3%

Lowercase Letter

Value	Count	Frequency (%)
o	1044	11.0%
e	998	10.6%
a	940	9.9%
n	940	9.9%
l	873	9.2%
r	813	8.6%
i	696	7.4%
s	567	6.0%
t	499	5.3%
u	258	2.7%
Other values (16)	1825	19.3%

Decimal Number

Value	Count	Frequency (%)
6	2	20.0%
8	2	20.0%
5	2	20.0%
0	2	20.0%
2	2	20.0%

Other Punctuation

Value	Count	Frequency (%)
.	271	73.2%
'	59	15.9%
,	40	10.8%

Space Separator

Value	Count	Frequency (%)
	12034	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	262	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	151	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	6	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	363389	96.6%
Common	12834	3.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	36799	10.1%
E	32773	9.0%
O	29514	8.1%
L	29423	8.1%
N	28734	7.9%
I	24008	6.6%
S	23939	6.6%
R	22162	6.1%
T	20421	5.6%
C	13141	3.6%
Other values (42)	102475	28.2%

Common

Value	Count	Frequency (%)
	12034	93.8%
.	271	2.1%
(	262	2.0%
)	151	1.2%
'	59	0.5%
,	40	0.3%
-	6	< 0.1%
6	2	< 0.1%
8	2	< 0.1%
5	2	< 0.1%
Other values (3)	5	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	376223	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	36799	9.8%
E	32773	8.7%
O	29514	7.8%
L	29423	7.8%
N	28734	7.6%
I	24008	6.4%
S	23939	6.4%
R	22162	5.9%
T	20421	5.4%
C	13141	3.5%
Other values (55)	115309	30.6%

State
Text

Distinct	51
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	661.0 KiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	84614
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AZ
2nd row	OK
3rd row	NJ
4th row	TN
5th row	CA

Value	Count	Frequency (%)
ca	6893	16.3%
tx	4095	9.7%
ny	2953	7.0%
pa	2849	6.7%
fl	1920	4.5%
oh	1229	2.9%
ut	1166	2.8%
tn	1147	2.7%
wa	1050	2.5%
mn	1004	2.4%
Other values (41)	18001	42.5%

Most occurring characters

Value	Count	Frequency (%)
A	14780	17.5%
C	8921	10.5%
N	8694	10.3%
T	7296	8.6%
M	5576	6.6%
I	4601	5.4%
O	4135	4.9%
X	4095	4.8%
Y	3796	4.5%
L	3394	4.0%
Other values (14)	19326	22.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	84614	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	14780	17.5%
C	8921	10.5%
N	8694	10.3%
T	7296	8.6%
M	5576	6.6%
I	4601	5.4%
O	4135	4.9%
X	4095	4.8%
Y	3796	4.5%
L	3394	4.0%
Other values (14)	19326	22.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	84614	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	14780	17.5%
C	8921	10.5%
N	8694	10.3%
T	7296	8.6%
M	5576	6.6%
I	4601	5.4%
O	4135	4.9%
X	4095	4.8%
Y	3796	4.5%
L	3394	4.0%
Other values (14)	19326	22.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	84614	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	14780	17.5%
C	8921	10.5%
N	8694	10.3%
T	7296	8.6%
M	5576	6.6%
I	4601	5.4%
O	4135	4.9%
X	4095	4.8%
Y	3796	4.5%
L	3394	4.0%
Other values (14)	19326	22.8%

BankState
Text

Distinct	51
Distinct (%)	0.1%
Missing	11
Missing (%)	< 0.1%
Memory size	661.0 KiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	84592
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SD
2nd row	OK
3rd row	NJ
4th row	SD
5th row	CA

Value	Count	Frequency (%)
ca	6476	15.3%
nc	3320	7.8%
il	2944	7.0%
oh	2785	6.6%
ri	2541	6.0%
tx	2457	5.8%
sd	2382	5.6%
ny	2197	5.2%
pa	1307	3.1%
ut	1133	2.7%
Other values (41)	14754	34.9%

Most occurring characters

Value	Count	Frequency (%)
A	11316	13.4%
C	10852	12.8%
N	8915	10.5%
I	7447	8.8%
T	5135	6.1%
O	5117	6.0%
L	4216	5.0%
M	4099	4.8%
D	3776	4.5%
H	3208	3.8%
Other values (14)	20511	24.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	84592	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	11316	13.4%
C	10852	12.8%
N	8915	10.5%
I	7447	8.8%
T	5135	6.1%
O	5117	6.0%
L	4216	5.0%
M	4099	4.8%
D	3776	4.5%
H	3208	3.8%
Other values (14)	20511	24.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	84592	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	11316	13.4%
C	10852	12.8%
N	8915	10.5%
I	7447	8.8%
T	5135	6.1%
O	5117	6.0%
L	4216	5.0%
M	4099	4.8%
D	3776	4.5%
H	3208	3.8%
Other values (14)	20511	24.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	84592	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	11316	13.4%
C	10852	12.8%
N	8915	10.5%
I	7447	8.8%
T	5135	6.1%
O	5117	6.0%
L	4216	5.0%
M	4099	4.8%
D	3776	4.5%
H	3208	3.8%
Other values (14)	20511	24.2%

DisbursementGross
Real number (ℝ)

Distinct	2694
Distinct (%)	6.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17935735

Minimum	400000
Maximum	6.296554 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	661.0 KiB

Quantile statistics

Minimum	400000
5-th percentile	1000000
Q1	3900000
median	9992200
Q3	21800000
95-th percentile	67570000
Maximum	6.296554 × 10⁸
Range	6.292554 × 10⁸
Interquartile range (IQR)	17900000

Descriptive statistics

Standard deviation	24872317
Coefficient of variation (CV)	1.3867465
Kurtosis	23.630558
Mean	17935735
Median Absolute Deviation (MAD)	7022200
Skewness	3.5277948
Sum	7.5880714 × 10¹¹
Variance	6.1863217 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10000000	2773	6.6%
5000000	2016	4.8%
2500000	1433	3.4%
500000	1298	3.1%
6000000	1041	2.5%
15000000	971	2.3%
8000000	955	2.3%
14500000	773	1.8%
1700000	729	1.7%
1000000	690	1.6%
Other values (2684)	29628	70.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
400000	246	0.6%
405300	2	< 0.1%
440000	1	< 0.1%
451000	1	< 0.1%
500000	1298	3.1%
500900	6	< 0.1%
505600	1	< 0.1%
509900	2	< 0.1%
510000	1	< 0.1%
528500	1	< 0.1%

Value	Count	Frequency (%)
629655400	1	< 0.1%
325900000	3	< 0.1%
300000000	4	< 0.1%
287100000	1	< 0.1%
250000000	2	< 0.1%
229350000	7	< 0.1%
222525300	1	< 0.1%
200000000	57	0.1%
199900000	2	< 0.1%
199770000	3	< 0.1%

GrAppv
Real number (ℝ)

Distinct	1425
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17395940

Minimum	200000
Maximum	3.5 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	661.0 KiB

Quantile statistics

Minimum	200000
5-th percentile	900000
Q1	3000000
median	8500000
Q3	20250000
95-th percentile	67000000
Maximum	3.5 × 10⁸
Range	3.498 × 10⁸
Interquartile range (IQR)	17250000

Descriptive statistics

Standard deviation	24726574
Coefficient of variation (CV)	1.4213992
Kurtosis	16.300384
Mean	17395940
Median Absolute Deviation (MAD)	6000000
Skewness	3.2930646
Sum	7.3597002 × 10¹¹
Variance	6.1140345 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10000000	3257	7.7%
5000000	2934	6.9%
2500000	2153	5.1%
500000	1426	3.4%
1000000	1330	3.1%
6000000	1088	2.6%
15000000	1051	2.5%
8000000	988	2.3%
1500000	905	2.1%
2000000	902	2.1%
Other values (1415)	26273	62.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
200000	2	< 0.1%
300000	15	< 0.1%
350000	3	< 0.1%
400000	244	0.6%
440000	1	< 0.1%
500000	1426	3.4%
510000	1	< 0.1%
530000	1	< 0.1%
540000	4	< 0.1%
550000	4	< 0.1%

Value	Count	Frequency (%)
350000000	1	< 0.1%
347100000	3	< 0.1%
300000000	4	< 0.1%
287100000	1	< 0.1%
250000000	2	< 0.1%
236000000	2	< 0.1%
200000000	57	0.1%
199900000	2	< 0.1%
199770000	3	< 0.1%
199000000	3	< 0.1%

SBA_Appv
Real number (ℝ)

Distinct	2005
Distinct (%)	4.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13760125

Minimum	100000
Maximum	3.471 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	661.0 KiB

Quantile statistics

Minimum	100000
5-th percentile	500000
Q1	2000000
median	6400000
Q3	16125000
95-th percentile	53959500
Maximum	3.471 × 10⁸
Range	3.47 × 10⁸
Interquartile range (IQR)	14125000

Descriptive statistics

Standard deviation	20556206
Coefficient of variation (CV)	1.4938967
Kurtosis	20.441211
Mean	13760125
Median Absolute Deviation (MAD)	5150000
Skewness	3.542001
Sum	5.8214963 × 10¹¹
Variance	4.2255759 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2500000	2382	5.6%
1250000	1705	4.0%
9000000	1023	2.4%
425000	985	2.3%
5000000	982	2.3%
500000	957	2.3%
11600000	757	1.8%
5100000	742	1.8%
8000000	729	1.7%
1360000	715	1.7%
Other values (1995)	31330	74.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
100000	2	< 0.1%
150000	15	< 0.1%
175000	3	< 0.1%
220000	1	< 0.1%
250000	394	0.9%
255000	1	< 0.1%
265000	1	< 0.1%
270000	4	< 0.1%
275000	4	< 0.1%
310000	2	< 0.1%

Value	Count	Frequency (%)
347100000	3	< 0.1%
287100000	1	< 0.1%
270000000	4	< 0.1%
262500000	1	< 0.1%
225000000	2	< 0.1%
200000000	8	< 0.1%
199900000	2	< 0.1%
174400000	2	< 0.1%
160200000	2	< 0.1%
150000000	41	0.1%

UrbanRural
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	661.0 KiB

0	24037
1	11759
2	6511

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	42307
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	1
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	24037	56.8%
1	11759	27.8%
2	6511	15.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	24037	56.8%
1	11759	27.8%
2	6511	15.4%

Most occurring characters

Value	Count	Frequency (%)
0	24037	56.8%
1	11759	27.8%
2	6511	15.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	42307	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	24037	56.8%
1	11759	27.8%
2	6511	15.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	42307	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	24037	56.8%
1	11759	27.8%
2	6511	15.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	42307	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	24037	56.8%
1	11759	27.8%
2	6511	15.4%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Term	NoEmp	NewExist	CreateJob	RetainedJob	FranchiseCode	RevLineCr	LowDoc	DisbursementDate	MIS_Status	Sector	ApprovalDate	ApprovalFY	City	State	BankState	DisbursementGross	GrAppv	SBA_Appv	UrbanRural
0	163	21	1.0	0	0	1	N	N	31-Jan-98	1	0	22-Sep-06	2006	PHOENIX	AZ	SD	8000000	8000000	6800000	0
1	84	6	1.0	4	0	0	0	N	31-Oct-93	1	62	30-Jun-92	1992	MCALESTER	OK	OK	28700000	28700000	22960000	0
2	242	45	1.0	4	90	0	N	N	31-Aug-01	1	42	18-Apr-01	2001	HAWTHORNE	NJ	NJ	3198300	3000000	1500000	1
3	237	4	1.0	0	0	0	N	N	31-Aug-07	1	33	6-Oct-03	2004	NASHVILLE	TN	SD	22900000	22900000	22900000	0
4	184	0	1.0	0	0	0	N	N	8-Jun-83	1	0	17-Dec-99	2000	POMONA	CA	CA	52500000	52500000	39375000	0
5	60	7	1.0	4	10	0	Y	N	1-Apr-12	0	44	26-Nov-93	1994	APLINGTON	IA	IA	6999100	7000000	3500000	0
6	39	0	1.0	15	1	0	0	N	8-Nov-11	1	23	4-Jan-05	2005	DALLAS	TX	CA	5000000	5000000	2500000	0
7	82	5	2.0	0	0	1	N	C	31-Jan-95	1	0	21-Nov-01	2002	HUDSON	NH	NH	41400000	41400000	41400000	0
8	57	6	2.0	0	0	0	N	C	31-Jan-95	1	61	11-Jan-95	1995	WILLISTON	ND	ND	11250000	11250000	10125000	0
9	25	1	1.0	0	0	1	N	N	30-Apr-07	1	0	23-Mar-04	2004	MESA	AZ	AZ	5000000	5000000	2500000	2

	Term	NoEmp	NewExist	CreateJob	RetainedJob	FranchiseCode	RevLineCr	LowDoc	DisbursementDate	MIS_Status	Sector	ApprovalDate	ApprovalFY	City	State	BankState	DisbursementGross	GrAppv	SBA_Appv	UrbanRural
42297	57	2	1.0	0	0	960	N	N	29-Jun-01	1	0	8-Mar-96	1996	SACRAMENTO	CA	CO	10500000	10500000	8925000	0
42298	82	15	1.0	1	10	72590	0	N	30-Apr-06	1	44	15-May-03	2003	DALLAS	TX	TX	5000000	5000000	2500000	0
42299	10	2	1.0	0	1	0	Y	N	30-Jun-08	0	72	8-Mar-00	2000	CLARENCE	NY	NY	67000000	67000000	67000000	1
42300	82	3	1.0	0	0	1	N	N	31-Dec-05	1	42	9-Jul-03	2003	NEW YORK	NY	IL	15000000	15000000	13500000	0
42301	82	0	1.0	18	1	1	Y	N	10-Dec-96	1	23	7-Jul-09	2009	PITTSBURGH	PA	PA	500000	500000	425000	1
42302	283	14	1.0	0	0	1	N	N	31-Jan-98	1	0	2-Mar-95	1995	PHILADELPHIA	PA	PA	8000000	8000000	6800000	0
42303	53	2	1.0	0	0	0	Y	N	3-Apr-91	1	42	6-Jun-07	2007	LOS ANGELES	CA	SD	500000	500000	425000	1
42304	59	6	2.0	0	0	1	N	N	28-Feb-03	1	42	14-Mar-03	2003	COLUMBUS	OH	OH	6000000	6000000	5100000	0
42305	295	18	1.0	0	8	0	N	N	10-Dec-97	1	42	23-Aug-89	1989	CLOQUET	MN	MN	29400000	29400000	22050000	0
42306	84	4	1.0	0	8	0	N	N	31-Oct-89	1	72	12-Apr-11	2011	SAN GABRIEL	CA	NC	6750000	6750000	5062500	0

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Decimal Number

Other Punctuation

Space Separator

Open Punctuation

Close Punctuation

Dash Punctuation

Modifier Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories